Maintaining Budgets for a GL Account Template

In MGL, there are two different ways of entering budget information against accounts. This section tells you how to enter budget information manually – that is, you call up each account and then apply budget details directly to the account. The second way is using a budget matrix.

Reference For information on maintaining budgets using a budget matrix, refer to "File - Budget".

You can have four separate budgets (each for 24 months) for each account. The budgets are called Budget 1, Budget 2, Budget 3 and Budget 4. When running financial reports, e.g. the Profit & Loss Report, Micronet prompts you to choose a budget option for that report.

Usually a business decides on its budget for the coming financial year during May/June. The initial budget is set in Budget 1. However, conditions may change and a revised budget can be set – Budget 2, Budget 3, up to Budget 4.

Various recipients of the Profit & Loss Report can have their departmental Income and Expense Report compared against either the Initial Budget, the Revised Budget, or an Adjusted Forecast.

To enter budgets 1-4 for a T account combination in a GL account template:

1. Open the GL Template File Update screen - T Accounts tab and choose to add, insert or edit a T account combination.

Refer to "File - Template - T Accounts".

Micronet displays the Edit Sub T Account screen.

2. Complete the fields on the Edit Sub T Account screen.

Refer to "File - Template - T Accounts".

3. Select EDIT | BUDGETS and the number of the budget you want to add or change (1, 2, 3, or 4).

Micronet displays the Edit Sub Account Budget Set screen for the budget you selected.

4. Use one of the following methods of entering budget data:

• Enter the budget amount for each month in dollars as required.

Warning Always enter credit balances (income amounts) as negative amounts in the budget set.

• Select EDIT | YEARLY BUDGET – enter a total annual budget amount in dollars and select Accept. Micronet spreads the amount evenly over the 12 months.

Yearly Budget

• Select EDIT | MARKUP METHOD – enter an initial amount to which a markup percentage will be applied each month, then select Accept. Micronet applies the markup percentage to the figure you enter as the first month’s budget, and compounds by that percentage for each following month. The markup percentage is as set in the Budget Matrix field on the Account File Update screen - GL Account tab.

Starting Amount

• Select EDIT | CURRENT BALANCE METHOD – Micronet divides the YTD balance in the GL account by the number of months with transactions to calculate a standard monthly budget amount in dollars. If a Budget Matrix is set on the Account File Update screen - GL Account tab, these amounts will be marked up by the appropriate markup percentage.

5. When you have finished entering budgets for each month on the Edit Sub Account Budget Set screen, select the Accept button.

Micronet redisplays the Edit Sub T Account screen so you can add another budget for the T account combination if required.

6. When you have finished adding budgets on the Edit Sub T Account screen, select the Cancel button.

Micronet redisplays the GL Template File Update screen - T Accounts tab showing all the T account combinations for this GL account template.

7. Select FILE | SAVE.

8. If you want to:

• update all GL accounts with the changes you have made, refer to "Edit - Update GL Accounts"

• apply changes you have made to an account to the currently displayed GL template, refer to "Edit - Update GL Templates"

• apply changes you have made to this GL template to all GL templates, refer to "Edit - Update All Templates".